package com.hangxin.basic.sql;

public class UserSql {

	//crm人员列表，不包括已经添加的登录用户
	public final static String CRMUSERNOADD = "select * from (select A.*, rownum rn from (SELECT * FROM sys_employee where sys_employee.employee_id not in(select logininfo.employeeid from logininfo )) A where rownum <=?) where rn >=?";
	//crm人员合计，不包括已经添加的登录用户
	public final static String CRMUSERNOADDCOUNT = "SELECT COUNT(*) FROM sys_employee where sys_employee.employee_id not in(select logininfo.employeeid from logininfo )";
}
